package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 根据给定的用户名删除指定的用户
 */
public class Test {
    public static void main(String[] args) {
//        try (
//                Connection connection =DBUtil.getConnectiom();   //自动关闭特性
//        )
//        {
//
//            Statement statement = connection.createStatement();
//            String sql ="UPDATE userinfo " +
//                    "SET password ='888888' " +
//                    "WHERE username ='蒋敦豪'";
//            System.out.println(sql);
//            int num =statement.executeUpdate(sql);
//            if (num>0){
//                System.out.println("修改成功");
//            }else{
//                System.out.println("修改失败");
//            }
////            connection.close();
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
        UserInfo userInfo = InputUtil.getInputObject(new UserInfo(),"删除用户","删除");
        System.out.println(userInfo);
        try(
                Connection connection =DBUtil.getConnectiom();)
        {
            Statement statement = connection.createStatement();
            String sql = "DELETE FROM userinfo " +
                    "WHERE username='"+userInfo.getUsername()+"'";
            int num = statement.executeUpdate(sql);
            System.out.println("删除"+(num>0?"成功":"失败"));
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}
